Dataset info
| Number of variables | 43 |
|---|---|
| Number of observations | 85256 |
| Missing cells | 0 (0.0%) |
| Duplicate rows | 0 (0.0%) |
| Total size in memory | 28.0 MiB |
| Average record size in memory | 344.0 B |
Variables types
| Numeric | 22 |
|---|---|
| Categorical | 6 |
| Boolean | 0 |
| Date | 0 |
| URL | 0 |
| Text (Unique) | 0 |
| Rejected | 15 |
| Unsupported | 0 |
Warnings
availability_365 has 28847 (33.8%) zeros | Zeros |
bedrooms has 5186 (6.1%) zeros | Zeros |
calculated_host_listings_count_entire_homes is highly correlated with calculated_host_listings_count (ρ = 0.9960387533) | Rejected |
calculated_host_listings_count_private_rooms has 41255 (48.4%) zeros | Zeros |
calculated_host_listings_count_shared_rooms has 84231 (98.8%) zeros | Zeros |
cleaning_fee has 27458 (32.2%) zeros | Zeros |
days_from_last_review has 21224 (24.9%) zeros | Zeros |
extra_people has 52157 (61.2%) zeros | Zeros |
host_has_profile_pic has constant value "0" | Rejected |
host_identity_verified has constant value "0" | Rejected |
host_is_superhost has constant value "0" | Rejected |
instant_bookable has constant value "0" | Rejected |
is_location_exact has constant value "0" | Rejected |
maximum_nights is highly skewed (γ1 = 229.4290999) | Skewed |
minimum_nights is highly skewed (γ1 = 31.59442608) | Skewed |
number_of_reviews has 20994 (24.6%) zeros | Zeros |
number_of_reviews_ltm has 35457 (41.6%) zeros | Zeros |
price is highly skewed (γ1 = 34.70050122) | Skewed |
require_guest_phone_verification has constant value "0" | Rejected |
require_guest_profile_picture has constant value "0" | Rejected |
requires_license has constant value "0" | Rejected |
review_scores_accuracy has 22724 (26.7%) zeros | Zeros |
review_scores_checkin is highly correlated with review_scores_accuracy (ρ = 0.9848085209) | Rejected |
review_scores_cleanliness is highly correlated with review_scores_checkin (ρ = 0.9753795463) | Rejected |
review_scores_communication is highly correlated with review_scores_cleanliness (ρ = 0.9771412106) | Rejected |
review_scores_location is highly correlated with review_scores_communication (ρ = 0.9821447746) | Rejected |
review_scores_rating is highly correlated with review_scores_location (ρ = 0.9790794651) | Rejected |
review_scores_value is highly correlated with review_scores_rating (ρ = 0.9880247363) | Rejected |
reviews_per_month has 20994 (24.6%) zeros | Zeros |
security_deposit has 49259 (57.8%) zeros | Zeros |
accommodates
Numeric
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 3.203575115 |
|---|---|
| Minimum | 1 |
| Maximum | 30 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| Median | 2 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 30 |
| Range | 29 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 2.024889844 |
|---|---|
| Coef of variation | 0.6320719106 |
| Kurtosis | 4.674586914 |
| Mean | 3.203575115 |
| MAD | 1.58603516 |
| Skewness | 1.705247084 |
| Sum | 273124 |
| Variance | 4.100178879 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 2 | 35768 | 42.0% | |
| 4 | 17022 | 20.0% | |
| 1 | 10605 | 12.4% | |
| 6 | 6899 | 8.1% | |
| 3 | 5851 | 6.9% | |
| 5 | 4033 | 4.7% | |
| 8 | 2106 | 2.5% | |
| 7 | 1374 | 1.6% | |
| 10 | 569 | 0.7% | |
| 9 | 448 | 0.5% | |
| Other values (8) | 581 | 0.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 10605 | 12.4% | |
| 2 | 35768 | 42.0% | |
| 3 | 5851 | 6.9% | |
| 4 | 17022 | 20.0% | |
| 5 | 4033 | 4.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 30 | 1 | < 0.1% | |
| 20 | 1 | < 0.1% | |
| 16 | 101 | 0.1% | |
| 15 | 24 | < 0.1% | |
| 14 | 90 | 0.1% |
availability_365
Numeric
| Distinct count | 366 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 118.7642747 |
|---|---|
| Minimum | 0 |
| Maximum | 365 |
| Zeros (%) | 33.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 61 |
| Q3 | 252 |
| 95-th percentile | 362 |
| Maximum | 365 |
| Range | 365 |
| Interquartile range | 252 |
Descriptive statistics
| Standard deviation | 134.7248155 |
|---|---|
| Coef of variation | 1.1343884 |
| Kurtosis | -1.085954873 |
| Mean | 118.7642747 |
| MAD | 119.0384525 |
| Skewness | 0.7224855149 |
| Sum | 10125367 |
| Variance | 18150.7759 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 28847 | 33.8% | |
| 365 | 2177 | 2.6% | |
| 364 | 1271 | 1.5% | |
| 1 | 845 | 1.0% | |
| 89 | 680 | 0.8% | |
| 90 | 673 | 0.8% | |
| 363 | 625 | 0.7% | |
| 257 | 578 | 0.7% | |
| 179 | 510 | 0.6% | |
| 2 | 498 | 0.6% | |
| Other values (356) | 48552 | 56.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 28847 | 33.8% | |
| 1 | 845 | 1.0% | |
| 2 | 498 | 0.6% | |
| 3 | 492 | 0.6% | |
| 4 | 412 | 0.5% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 365 | 2177 | 2.6% | |
| 364 | 1271 | 1.5% | |
| 363 | 625 | 0.7% | |
| 362 | 348 | 0.4% | |
| 361 | 227 | 0.3% |
bathrooms
Numeric
| Distinct count | 23 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.308734869 |
|---|---|
| Minimum | 0.5 |
| Maximum | 17 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 0.5 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 1.5 |
| 95-th percentile | 2.5 |
| Maximum | 17 |
| Range | 16.5 |
| Interquartile range | 0.5 |
Descriptive statistics
| Standard deviation | 0.609841339 |
|---|---|
| Coef of variation | 0.4659777572 |
| Kurtosis | 29.98131417 |
| Mean | 1.308734869 |
| MAD | 0.4386259562 |
| Skewness | 3.654230898 |
| Sum | 111577.5 |
| Variance | 0.3719064588 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 59774 | 70.1% | |
| 2 | 12304 | 14.4% | |
| 1.5 | 7878 | 9.2% | |
| 2.5 | 2426 | 2.8% | |
| 3 | 1436 | 1.7% | |
| 3.5 | 554 | 0.6% | |
| 0.5 | 301 | 0.4% | |
| 4 | 264 | 0.3% | |
| 4.5 | 114 | 0.1% | |
| 5 | 67 | 0.1% | |
| Other values (13) | 138 | 0.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0.5 | 301 | 0.4% | |
| 1 | 59774 | 70.1% | |
| 1.5 | 7878 | 9.2% | |
| 2 | 12304 | 14.4% | |
| 2.5 | 2426 | 2.8% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 17 | 1 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 10.5 | 1 | < 0.1% | |
| 10 | 23 | < 0.1% | |
| 9.5 | 1 | < 0.1% |
bed_type
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Real Bed | |
|---|---|
| Pull-out Sofa | 409 |
| Futon | 180 |
| Other values (2) | 108 |
| Value | Count | Frequency (%) | |
| Real Bed | 84559 | 99.2% | |
| Pull-out Sofa | 409 | 0.5% | |
| Futon | 180 | 0.2% | |
| Couch | 66 | 0.1% | |
| Airbed | 42 | < 0.1% |
| Max length | 13 |
|---|---|
| Mean length | 8.014345031 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
bedrooms
Numeric
| Distinct count | 15 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.416780051 |
|---|---|
| Minimum | 0 |
| Maximum | 22 |
| Zeros (%) | 6.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 22 |
| Range | 22 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 0.9230657463 |
|---|---|
| Coef of variation | 0.6515236757 |
| Kurtosis | 8.901296439 |
| Mean | 1.416780051 |
| MAD | 0.6928573736 |
| Skewness | 1.959663023 |
| Sum | 120789 |
| Variance | 0.8520503719 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 53236 | 62.4% | |
| 2 | 17613 | 20.7% | |
| 3 | 5951 | 7.0% | |
| 0 | 5186 | 6.1% | |
| 4 | 2289 | 2.7% | |
| 5 | 722 | 0.8% | |
| 6 | 182 | 0.2% | |
| 7 | 49 | 0.1% | |
| 8 | 12 | < 0.1% | |
| 10 | 6 | < 0.1% | |
| Other values (5) | 10 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 5186 | 6.1% | |
| 1 | 53236 | 62.4% | |
| 2 | 17613 | 20.7% | |
| 3 | 5951 | 7.0% | |
| 4 | 2289 | 2.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 22 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% | |
| 12 | 1 | < 0.1% | |
| 11 | 2 | < 0.1% | |
| 10 | 6 | < 0.1% |
beds
Numeric
| Distinct count | 21 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.779112321 |
|---|---|
| Minimum | 1 |
| Maximum | 28 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 28 |
| Range | 27 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.25350131 |
|---|---|
| Coef of variation | 0.7045655836 |
| Kurtosis | 17.45180105 |
| Mean | 1.779112321 |
| MAD | 0.8902182555 |
| Skewness | 2.971945767 |
| Sum | 151680 |
| Variance | 1.571265535 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 48707 | 57.1% | |
| 2 | 20661 | 24.2% | |
| 3 | 8664 | 10.2% | |
| 4 | 3998 | 4.7% | |
| 5 | 1623 | 1.9% | |
| 6 | 842 | 1.0% | |
| 7 | 325 | 0.4% | |
| 8 | 201 | 0.2% | |
| 10 | 75 | 0.1% | |
| 9 | 70 | 0.1% | |
| Other values (11) | 90 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 48707 | 57.1% | |
| 2 | 20661 | 24.2% | |
| 3 | 8664 | 10.2% | |
| 4 | 3998 | 4.7% | |
| 5 | 1623 | 1.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 28 | 1 | < 0.1% | |
| 20 | 3 | < 0.1% | |
| 19 | 2 | < 0.1% | |
| 18 | 2 | < 0.1% | |
| 17 | 2 | < 0.1% |
calculated_host_listings_count
Numeric
| Distinct count | 85 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 24.93694285 |
|---|---|
| Minimum | 1 |
| Maximum | 1130 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 5 |
| 95-th percentile | 65 |
| Maximum | 1130 |
| Range | 1129 |
| Interquartile range | 4 |
Descriptive statistics
| Standard deviation | 131.1053418 |
|---|---|
| Coef of variation | 5.257474526 |
| Kurtosis | 63.95465969 |
| Mean | 24.93694285 |
| MAD | 38.96093857 |
| Skewness | 7.970800517 |
| Sum | 2126024 |
| Variance | 17188.61065 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 43834 | 51.4% | |
| 2 | 12034 | 14.1% | |
| 3 | 4968 | 5.8% | |
| 4 | 2924 | 3.4% | |
| 5 | 1795 | 2.1% | |
| 6 | 1422 | 1.7% | |
| 7 | 1148 | 1.3% | |
| 1130 | 1130 | 1.3% | |
| 8 | 832 | 1.0% | |
| 9 | 729 | 0.9% | |
| Other values (75) | 14440 | 16.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 43834 | 51.4% | |
| 2 | 12034 | 14.1% | |
| 3 | 4968 | 5.8% | |
| 4 | 2924 | 3.4% | |
| 5 | 1795 | 2.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1130 | 1130 | 1.3% | |
| 227 | 227 | 0.3% | |
| 220 | 220 | 0.3% | |
| 196 | 196 | 0.2% | |
| 189 | 189 | 0.2% |
calculated_host_listings_count_entire_homes
Highly correlated
This variable is highly correlated with calculated_host_listings_count and should be ignored for analysis
| Correlation | 0.9960387533 |
|---|
calculated_host_listings_count_private_rooms
Numeric
| Distinct count | 37 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.916193582 |
|---|---|
| Minimum | 0 |
| Maximum | 135 |
| Zeros (%) | 48.4% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 1 |
| 95-th percentile | 6 |
| Maximum | 135 |
| Range | 135 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 7.989589293 |
|---|---|
| Coef of variation | 4.169510518 |
| Kurtosis | 167.7052271 |
| Mean | 1.916193582 |
| MAD | 2.412663736 |
| Skewness | 11.80937236 |
| Sum | 163367 |
| Variance | 63.83353707 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 41255 | 48.4% | |
| 1 | 25971 | 30.5% | |
| 2 | 6968 | 8.2% | |
| 3 | 3836 | 4.5% | |
| 4 | 1429 | 1.7% | |
| 5 | 1263 | 1.5% | |
| 6 | 600 | 0.7% | |
| 7 | 563 | 0.7% | |
| 10 | 358 | 0.4% | |
| 8 | 305 | 0.4% | |
| Other values (27) | 2708 | 3.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 41255 | 48.4% | |
| 1 | 25971 | 30.5% | |
| 2 | 6968 | 8.2% | |
| 3 | 3836 | 4.5% | |
| 4 | 1429 | 1.7% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 135 | 144 | 0.2% | |
| 96 | 101 | 0.1% | |
| 89 | 93 | 0.1% | |
| 41 | 73 | 0.1% | |
| 39 | 91 | 0.1% |
calculated_host_listings_count_shared_rooms
Numeric
| Distinct count | 13 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.04648353195 |
|---|---|
| Minimum | 0 |
| Maximum | 18 |
| Zeros (%) | 98.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range | 0 |
Descriptive statistics
| Standard deviation | 0.6880157106 |
|---|---|
| Coef of variation | 14.80127868 |
| Kurtosis | 436.2317613 |
| Mean | 0.04648353195 |
| MAD | 0.09184935675 |
| Skewness | 19.92881923 |
| Sum | 3963 |
| Variance | 0.473365618 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 84231 | 98.8% | |
| 1 | 664 | 0.8% | |
| 12 | 56 | 0.1% | |
| 17 | 53 | 0.1% | |
| 2 | 45 | 0.1% | |
| 8 | 38 | < 0.1% | |
| 7 | 36 | < 0.1% | |
| 9 | 32 | < 0.1% | |
| 4 | 25 | < 0.1% | |
| 3 | 24 | < 0.1% | |
| Other values (3) | 52 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 84231 | 98.8% | |
| 1 | 664 | 0.8% | |
| 2 | 45 | 0.1% | |
| 3 | 24 | < 0.1% | |
| 4 | 25 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 18 | 22 | < 0.1% | |
| 17 | 53 | 0.1% | |
| 12 | 56 | 0.1% | |
| 10 | 11 | < 0.1% | |
| 9 | 32 | < 0.1% |
cancellation_policy
Categorical
| Distinct count | 8 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| strict_14_with_grace_period | |
|---|---|
| flexible | |
| moderate | |
| Other values (5) | 870 |
| Value | Count | Frequency (%) | |
| strict_14_with_grace_period | 36611 | 42.9% | |
| flexible | 27728 | 32.5% | |
| moderate | 20047 | 23.5% | |
| super_strict_60 | 473 | 0.6% | |
| super_strict_30 | 366 | 0.4% | |
| luxury_moderate | 20 | < 0.1% | |
| strict | 8 | < 0.1% | |
| luxury_super_strict_95 | 3 | < 0.1% |
| Max length | 27 |
|---|---|
| Mean length | 16.22989584 |
| Min length | 6 |
| Contains chars | True |
| Contains digits | True |
| Contains spaces | False |
| Contains non-words | False |
cleaning_fee
Numeric
| Distinct count | 258 |
|---|---|
| Unique (%) | 0.3% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 32.36325889 |
|---|---|
| Minimum | 0 |
| Maximum | 2087 |
| Zeros (%) | 32.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 20 |
| Q3 | 50 |
| 95-th percentile | 100 |
| Maximum | 2087 |
| Range | 2087 |
| Interquartile range | 50 |
Descriptive statistics
| Standard deviation | 44.963326 |
|---|---|
| Coef of variation | 1.389332457 |
| Kurtosis | 115.0931106 |
| Mean | 32.36325889 |
| MAD | 29.84659018 |
| Skewness | 5.286944431 |
| Sum | 2759162 |
| Variance | 2021.700685 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 27458 | 32.2% | |
| 20 | 5240 | 6.1% | |
| 30 | 5103 | 6.0% | |
| 10 | 4547 | 5.3% | |
| 50 | 3880 | 4.6% | |
| 15 | 3689 | 4.3% | |
| 40 | 3677 | 4.3% | |
| 25 | 3271 | 3.8% | |
| 60 | 2506 | 2.9% | |
| 35 | 1961 | 2.3% | |
| Other values (248) | 23924 | 28.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 27458 | 32.2% | |
| 4 | 276 | 0.3% | |
| 5 | 1615 | 1.9% | |
| 6 | 215 | 0.3% | |
| 7 | 270 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2087 | 1 | < 0.1% | |
| 2000 | 1 | < 0.1% | |
| 1000 | 1 | < 0.1% | |
| 950 | 1 | < 0.1% | |
| 660 | 1 | < 0.1% |
days_from_last_review
Numeric
| Distinct count | 1776 |
|---|---|
| Unique (%) | 2.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 178.5129844 |
|---|---|
| Minimum | 0 |
| Maximum | 2997 |
| Zeros (%) | 24.9% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 29 |
| Q3 | 167 |
| 95-th percentile | 977 |
| Maximum | 2997 |
| Range | 2997 |
| Interquartile range | 166 |
Descriptive statistics
| Standard deviation | 326.9472195 |
|---|---|
| Coef of variation | 1.831503857 |
| Kurtosis | 6.58648769 |
| Mean | 178.5129844 |
| MAD | 225.3088692 |
| Skewness | 2.517895321 |
| Sum | 15219303 |
| Variance | 106894.4843 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 21224 | 24.9% | |
| 20 | 1274 | 1.5% | |
| 14 | 1251 | 1.5% | |
| 19 | 1129 | 1.3% | |
| 7 | 1102 | 1.3% | |
| 15 | 1099 | 1.3% | |
| 21 | 1068 | 1.3% | |
| 16 | 916 | 1.1% | |
| 28 | 914 | 1.1% | |
| 3 | 852 | 1.0% | |
| Other values (1766) | 54427 | 63.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 21224 | 24.9% | |
| 1 | 485 | 0.6% | |
| 2 | 786 | 0.9% | |
| 3 | 852 | 1.0% | |
| 4 | 769 | 0.9% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 2997 | 1 | < 0.1% | |
| 2886 | 1 | < 0.1% | |
| 2729 | 1 | < 0.1% | |
| 2667 | 1 | < 0.1% | |
| 2663 | 1 | < 0.1% |
df_index
Numeric
| Distinct count | 85256 |
|---|---|
| Unique (%) | 100.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 42641.13933 |
|---|---|
| Minimum | 0 |
| Maximum | 85273 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 4265.75 |
| Q1 | 21324.75 |
| Median | 42642.5 |
| Q3 | 63959.25 |
| 95-th percentile | 81010.25 |
| Maximum | 85273 |
| Range | 85273 |
| Interquartile range | 42634.5 |
Descriptive statistics
| Standard deviation | 24615.94141 |
|---|---|
| Coef of variation | 0.5772815125 |
| Kurtosis | -1.199890097 |
| Mean | 42641.13933 |
| MAD | 21317.57207 |
| Skewness | -0.0002328568823 |
| Sum | 3635412975 |
| Variance | 605944571.4 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 2047 | 1 | < 0.1% | |
| 29339 | 1 | < 0.1% | |
| 17053 | 1 | < 0.1% | |
| 23198 | 1 | < 0.1% | |
| 21151 | 1 | < 0.1% | |
| 76464 | 1 | < 0.1% | |
| 74417 | 1 | < 0.1% | |
| 80562 | 1 | < 0.1% | |
| 78515 | 1 | < 0.1% | |
| 68276 | 1 | < 0.1% | |
| Other values (85246) | 85246 | > 99.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 1 | < 0.1% | |
| 1 | 1 | < 0.1% | |
| 2 | 1 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 1 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 85273 | 1 | < 0.1% | |
| 85272 | 1 | < 0.1% | |
| 85271 | 1 | < 0.1% | |
| 85270 | 1 | < 0.1% | |
| 85269 | 1 | < 0.1% |
experiences_offered
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| none | |
|---|---|
| business | 598 |
| family | 493 |
| Other values (2) | 642 |
| Value | Count | Frequency (%) | |
| none | 83523 | 98.0% | |
| business | 598 | 0.7% | |
| family | 493 | 0.6% | |
| social | 426 | 0.5% | |
| romantic | 216 | 0.3% |
| Max length | 8 |
|---|---|
| Mean length | 4.05974946 |
| Min length | 4 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | False |
| Contains non-words | False |
extra_people
Numeric
| Distinct count | 113 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 7.409437459 |
|---|---|
| Minimum | 0 |
| Maximum | 248 |
| Zeros (%) | 61.2% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 10 |
| 95-th percentile | 30 |
| Maximum | 248 |
| Range | 248 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 13.97134259 |
|---|---|
| Coef of variation | 1.885614484 |
| Kurtosis | 50.97729368 |
| Mean | 7.409437459 |
| MAD | 9.231618891 |
| Skewness | 5.018658494 |
| Sum | 631699 |
| Variance | 195.1984138 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 52157 | 61.2% | |
| 10 | 7915 | 9.3% | |
| 15 | 6515 | 7.6% | |
| 20 | 4851 | 5.7% | |
| 25 | 2285 | 2.7% | |
| 5 | 2270 | 2.7% | |
| 30 | 1698 | 2.0% | |
| 50 | 1072 | 1.3% | |
| 12 | 662 | 0.8% | |
| 35 | 641 | 0.8% | |
| Other values (103) | 5190 | 6.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 52157 | 61.2% | |
| 3 | 1 | < 0.1% | |
| 4 | 329 | 0.4% | |
| 5 | 2270 | 2.7% | |
| 6 | 238 | 0.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 248 | 1 | < 0.1% | |
| 247 | 1 | < 0.1% | |
| 246 | 1 | < 0.1% | |
| 244 | 1 | < 0.1% | |
| 243 | 1 | < 0.1% |
guests_included
Numeric
| Distinct count | 16 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1.615182509 |
|---|---|
| Minimum | 1 |
| Maximum | 16 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 1 |
| Q3 | 2 |
| 95-th percentile | 4 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range | 1 |
Descriptive statistics
| Standard deviation | 1.355885252 |
|---|---|
| Coef of variation | 0.839462565 |
| Kurtosis | 15.30201454 |
| Mean | 1.615182509 |
| MAD | 0.8886434589 |
| Skewness | 3.306455215 |
| Sum | 137704 |
| Variance | 1.838424817 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 61577 | 72.2% | |
| 2 | 12951 | 15.2% | |
| 4 | 5594 | 6.6% | |
| 3 | 1621 | 1.9% | |
| 6 | 1595 | 1.9% | |
| 5 | 874 | 1.0% | |
| 8 | 469 | 0.6% | |
| 7 | 251 | 0.3% | |
| 10 | 138 | 0.2% | |
| 9 | 74 | 0.1% | |
| Other values (6) | 112 | 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 61577 | 72.2% | |
| 2 | 12951 | 15.2% | |
| 3 | 1621 | 1.9% | |
| 4 | 5594 | 6.6% | |
| 5 | 874 | 1.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 16 | 30 | < 0.1% | |
| 15 | 12 | < 0.1% | |
| 14 | 6 | < 0.1% | |
| 13 | 5 | < 0.1% | |
| 12 | 33 | < 0.1% |
host_days
Numeric
| Distinct count | 3427 |
|---|---|
| Unique (%) | 4.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 1415.539551 |
|---|---|
| Minimum | 1 |
| Maximum | 4028 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 144 |
| Q1 | 804 |
| Median | 1424 |
| Q3 | 1955 |
| 95-th percentile | 2746 |
| Maximum | 4028 |
| Range | 4027 |
| Interquartile range | 1151 |
Descriptive statistics
| Standard deviation | 789.5576678 |
|---|---|
| Coef of variation | 0.557778599 |
| Kurtosis | -0.6565240472 |
| Mean | 1415.539551 |
| MAD | 647.0778491 |
| Skewness | 0.1706063851 |
| Sum | 120683240 |
| Variance | 623401.3108 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1578 | 689 | 0.8% | |
| 1577 | 517 | 0.6% | |
| 690 | 252 | 0.3% | |
| 1410 | 246 | 0.3% | |
| 811 | 206 | 0.2% | |
| 1999 | 171 | 0.2% | |
| 1654 | 161 | 0.2% | |
| 2737 | 159 | 0.2% | |
| 311 | 155 | 0.2% | |
| 1655 | 134 | 0.2% | |
| Other values (3417) | 82566 | 96.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 3 | < 0.1% | |
| 2 | 22 | < 0.1% | |
| 3 | 30 | < 0.1% | |
| 4 | 29 | < 0.1% | |
| 5 | 20 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 4028 | 1 | < 0.1% | |
| 3938 | 7 | < 0.1% | |
| 3914 | 1 | < 0.1% | |
| 3894 | 3 | < 0.1% | |
| 3873 | 1 | < 0.1% |
host_has_profile_pic
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
host_identity_verified
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
host_is_superhost
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
instant_bookable
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
is_location_exact
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
maximum_nights
Numeric
| Distinct count | 309 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 20131.3483 |
|---|---|
| Minimum | 1 |
| Maximum | 999999999 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 31 |
| Median | 1125 |
| Q3 | 1125 |
| 95-th percentile | 1125 |
| Maximum | 999999999 |
| Range | 999999998 |
| Interquartile range | 1094 |
Descriptive statistics
| Standard deviation | 3883411.555 |
|---|---|
| Coef of variation | 192.9036991 |
| Kurtosis | 55488.47276 |
| Mean | 20131.3483 |
| MAD | 38820.04163 |
| Skewness | 229.4290999 |
| Sum | 1716318231 |
| Variance | 1.508088531e+13 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1125 | 50683 | 59.4% | |
| 30 | 4579 | 5.4% | |
| 14 | 3115 | 3.7% | |
| 7 | 2389 | 2.8% | |
| 90 | 2336 | 2.7% | |
| 365 | 1629 | 1.9% | |
| 60 | 1503 | 1.8% | |
| 10 | 1397 | 1.6% | |
| 21 | 1211 | 1.4% | |
| 1124 | 1142 | 1.3% | |
| Other values (299) | 15272 | 17.9% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 149 | 0.2% | |
| 2 | 313 | 0.4% | |
| 3 | 576 | 0.7% | |
| 4 | 617 | 0.7% | |
| 5 | 918 | 1.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 999999999 | 1 | < 0.1% | |
| 524855552 | 1 | < 0.1% | |
| 99999999 | 1 | < 0.1% | |
| 10000000 | 1 | < 0.1% | |
| 9999999 | 1 | < 0.1% |
minimum_nights
Numeric
| Distinct count | 109 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 4.12046073 |
|---|---|
| Minimum | 1 |
| Maximum | 1125 |
| Zeros (%) | 0.0% |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| Median | 2 |
| Q3 | 3 |
| 95-th percentile | 7 |
| Maximum | 1125 |
| Range | 1124 |
| Interquartile range | 2 |
Descriptive statistics
| Standard deviation | 15.65420824 |
|---|---|
| Coef of variation | 3.799140259 |
| Kurtosis | 1754.327182 |
| Mean | 4.12046073 |
| MAD | 3.728677938 |
| Skewness | 31.59442608 |
| Sum | 351294 |
| Variance | 245.0542357 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 1 | 28505 | 33.4% | |
| 2 | 25476 | 29.9% | |
| 3 | 13777 | 16.2% | |
| 4 | 4482 | 5.3% | |
| 5 | 4334 | 5.1% | |
| 7 | 3523 | 4.1% | |
| 6 | 1041 | 1.2% | |
| 14 | 804 | 0.9% | |
| 10 | 535 | 0.6% | |
| 30 | 490 | 0.6% | |
| Other values (99) | 2289 | 2.7% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 1 | 28505 | 33.4% | |
| 2 | 25476 | 29.9% | |
| 3 | 13777 | 16.2% | |
| 4 | 4482 | 5.3% | |
| 5 | 4334 | 5.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 1125 | 1 | < 0.1% | |
| 1124 | 2 | < 0.1% | |
| 1000 | 2 | < 0.1% | |
| 999 | 1 | < 0.1% | |
| 900 | 1 | < 0.1% |
neighbourhood_cleansed
Categorical
| Distinct count | 33 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Westminster | 9806 |
|---|---|
| Tower Hamlets | 8196 |
| Hackney | 6239 |
| Other values (30) |
| Value | Count | Frequency (%) | |
| Westminster | 9806 | 11.5% | |
| Tower Hamlets | 8196 | 9.6% | |
| Hackney | 6239 | 7.3% | |
| Kensington and Chelsea | 6023 | 7.1% | |
| Camden | 5960 | 7.0% | |
| Islington | 5129 | 6.0% | |
| Southwark | 4887 | 5.7% | |
| Lambeth | 4855 | 5.7% | |
| Wandsworth | 4352 | 5.1% | |
| Hammersmith and Fulham | 4190 | 4.9% | |
| Other values (23) | 25619 | 30.0% |
| Max length | 22 |
|---|---|
| Mean length | 10.62532842 |
| Min length | 5 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
number_of_reviews
Numeric
| Distinct count | 411 |
|---|---|
| Unique (%) | 0.5% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 16.81858168 |
|---|---|
| Minimum | 0 |
| Maximum | 690 |
| Zeros (%) | 24.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| Median | 4 |
| Q3 | 17 |
| 95-th percentile | 77 |
| Maximum | 690 |
| Range | 690 |
| Interquartile range | 16 |
Descriptive statistics
| Standard deviation | 35.6766822 |
|---|---|
| Coef of variation | 2.121265804 |
| Kurtosis | 38.66482822 |
| Mean | 16.81858168 |
| MAD | 19.77351716 |
| Skewness | 5.033163606 |
| Sum | 1433885 |
| Variance | 1272.825652 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 20994 | 24.6% | |
| 1 | 9290 | 10.9% | |
| 2 | 5929 | 7.0% | |
| 3 | 4538 | 5.3% | |
| 4 | 3622 | 4.2% | |
| 5 | 2872 | 3.4% | |
| 6 | 2480 | 2.9% | |
| 7 | 2087 | 2.4% | |
| 8 | 1914 | 2.2% | |
| 9 | 1698 | 2.0% | |
| Other values (401) | 29832 | 35.0% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20994 | 24.6% | |
| 1 | 9290 | 10.9% | |
| 2 | 5929 | 7.0% | |
| 3 | 4538 | 5.3% | |
| 4 | 3622 | 4.2% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 690 | 1 | < 0.1% | |
| 633 | 1 | < 0.1% | |
| 612 | 1 | < 0.1% | |
| 595 | 1 | < 0.1% | |
| 591 | 1 | < 0.1% |
number_of_reviews_ltm
Numeric
| Distinct count | 146 |
|---|---|
| Unique (%) | 0.2% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.613927466 |
|---|---|
| Minimum | 0 |
| Maximum | 231 |
| Zeros (%) | 41.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 1 |
| Q3 | 8 |
| 95-th percentile | 31 |
| Maximum | 231 |
| Range | 231 |
| Interquartile range | 8 |
Descriptive statistics
| Standard deviation | 12.70206888 |
|---|---|
| Coef of variation | 1.920503202 |
| Kurtosis | 20.65025294 |
| Mean | 6.613927466 |
| MAD | 7.887178862 |
| Skewness | 3.753936027 |
| Sum | 563877 |
| Variance | 161.3425538 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 35457 | 41.6% | |
| 1 | 8370 | 9.8% | |
| 2 | 5441 | 6.4% | |
| 3 | 4130 | 4.8% | |
| 4 | 3380 | 4.0% | |
| 5 | 2744 | 3.2% | |
| 6 | 2317 | 2.7% | |
| 7 | 2023 | 2.4% | |
| 8 | 1737 | 2.0% | |
| 9 | 1584 | 1.9% | |
| Other values (136) | 18073 | 21.2% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 35457 | 41.6% | |
| 1 | 8370 | 9.8% | |
| 2 | 5441 | 6.4% | |
| 3 | 4130 | 4.8% | |
| 4 | 3380 | 4.0% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 231 | 1 | < 0.1% | |
| 200 | 1 | < 0.1% | |
| 185 | 1 | < 0.1% | |
| 182 | 1 | < 0.1% | |
| 180 | 1 | < 0.1% |
price
Numeric
| Distinct count | 887 |
|---|---|
| Unique (%) | 1.0% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 129.7628906 |
|---|---|
| Minimum | 0 |
| Maximum | 20000 |
| Zeros (%) | < 0.1% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 25 |
| Q1 | 45 |
| Median | 82 |
| Q3 | 140 |
| 95-th percentile | 320 |
| Maximum | 20000 |
| Range | 20000 |
| Interquartile range | 95 |
Descriptive statistics
| Standard deviation | 444.3683826 |
|---|---|
| Coef of variation | 3.424464272 |
| Kurtosis | 1417.737463 |
| Mean | 129.7628906 |
| MAD | 93.21566626 |
| Skewness | 34.70050122 |
| Sum | 11063065 |
| Variance | 197463.2595 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 50 | 3106 | 3.6% | |
| 100 | 3065 | 3.6% | |
| 40 | 2795 | 3.3% | |
| 35 | 2529 | 3.0% | |
| 30 | 2363 | 2.8% | |
| 120 | 2358 | 2.8% | |
| 45 | 2303 | 2.7% | |
| 150 | 2280 | 2.7% | |
| 60 | 2245 | 2.6% | |
| 80 | 2226 | 2.6% | |
| Other values (877) | 59986 | 70.4% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 18 | < 0.1% | |
| 6 | 1 | < 0.1% | |
| 7 | 5 | < 0.1% | |
| 8 | 24 | < 0.1% | |
| 9 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 20000 | 27 | < 0.1% | |
| 13700 | 1 | < 0.1% | |
| 12345 | 17 | < 0.1% | |
| 10000 | 2 | < 0.1% | |
| 9999 | 3 | < 0.1% |
property_type
Categorical
| Distinct count | 43 |
|---|---|
| Unique (%) | 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Apartment | |
|---|---|
| House | |
| Townhouse | 2994 |
| Other values (40) | 7924 |
| Value | Count | Frequency (%) | |
| Apartment | 56389 | 66.1% | |
| House | 17949 | 21.1% | |
| Townhouse | 2994 | 3.5% | |
| Condominium | 2716 | 3.2% | |
| Serviced apartment | 1719 | 2.0% | |
| Loft | 739 | 0.9% | |
| Bed and breakfast | 647 | 0.8% | |
| Guest suite | 364 | 0.4% | |
| Guesthouse | 305 | 0.4% | |
| Boutique hotel | 242 | 0.3% | |
| Other values (33) | 1192 | 1.4% |
| Max length | 29 |
|---|---|
| Mean length | 8.412686497 |
| Min length | 3 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
require_guest_phone_verification
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
require_guest_profile_picture
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
requires_license
Constant
This variable is constant and should be ignored for analysis
| Constant value | 0 |
|---|
review_scores_accuracy
Numeric
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 6.968107816 |
|---|---|
| Minimum | 0 |
| Maximum | 10 |
| Zeros (%) | 26.7% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 9 |
| Q3 | 10 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 10 |
| Interquartile range | 10 |
Descriptive statistics
| Standard deviation | 4.286899361 |
|---|---|
| Coef of variation | 0.6152171398 |
| Kurtosis | -0.9990299447 |
| Mean | 6.968107816 |
| MAD | 3.786722304 |
| Skewness | -0.9567870511 |
| Sum | 594073 |
| Variance | 18.37750613 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 10 | 42478 | 49.8% | |
| 0 | 22724 | 26.7% | |
| 9 | 14160 | 16.6% | |
| 8 | 3716 | 4.4% | |
| 7 | 802 | 0.9% | |
| 6 | 761 | 0.9% | |
| 2 | 305 | 0.4% | |
| 4 | 189 | 0.2% | |
| 5 | 108 | 0.1% | |
| 3 | 13 | < 0.1% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 22724 | 26.7% | |
| 2 | 305 | 0.4% | |
| 3 | 13 | < 0.1% | |
| 4 | 189 | 0.2% | |
| 5 | 108 | 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 10 | 42478 | 49.8% | |
| 9 | 14160 | 16.6% | |
| 8 | 3716 | 4.4% | |
| 7 | 802 | 0.9% | |
| 6 | 761 | 0.9% |
review_scores_checkin
Highly correlated
This variable is highly correlated with review_scores_accuracy and should be ignored for analysis
| Correlation | 0.9848085209 |
|---|
review_scores_cleanliness
Highly correlated
This variable is highly correlated with review_scores_checkin and should be ignored for analysis
| Correlation | 0.9753795463 |
|---|
review_scores_communication
Highly correlated
This variable is highly correlated with review_scores_cleanliness and should be ignored for analysis
| Correlation | 0.9771412106 |
|---|
review_scores_location
Highly correlated
This variable is highly correlated with review_scores_communication and should be ignored for analysis
| Correlation | 0.9821447746 |
|---|
review_scores_rating
Highly correlated
This variable is highly correlated with review_scores_location and should be ignored for analysis
| Correlation | 0.9790794651 |
|---|
review_scores_value
Highly correlated
This variable is highly correlated with review_scores_rating and should be ignored for analysis
| Correlation | 0.9880247363 |
|---|
reviews_per_month
Numeric
| Distinct count | 932 |
|---|---|
| Unique (%) | 1.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 0.8885059116 |
|---|---|
| Minimum | 0 |
| Maximum | 48.21 |
| Zeros (%) | 24.6% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.02 |
| Median | 0.38 |
| Q3 | 1.2 |
| 95-th percentile | 3.5 |
| Maximum | 48.21 |
| Range | 48.21 |
| Interquartile range | 1.18 |
Descriptive statistics
| Standard deviation | 1.29793727 |
|---|---|
| Coef of variation | 1.460808818 |
| Kurtosis | 31.2138114 |
| Mean | 0.8885059116 |
| MAD | 0.8964249093 |
| Skewness | 3.174200175 |
| Sum | 75750.46 |
| Variance | 1.684641158 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 20994 | 24.6% | |
| 1 | 1889 | 2.2% | |
| 0.04 | 1066 | 1.3% | |
| 0.08 | 1022 | 1.2% | |
| 0.05 | 954 | 1.1% | |
| 0.07 | 923 | 1.1% | |
| 0.02 | 921 | 1.1% | |
| 0.03 | 895 | 1.0% | |
| 0.12 | 802 | 0.9% | |
| 0.06 | 800 | 0.9% | |
| Other values (922) | 54990 | 64.5% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 20994 | 24.6% | |
| 0.01 | 34 | < 0.1% | |
| 0.02 | 921 | 1.1% | |
| 0.03 | 895 | 1.0% | |
| 0.04 | 1066 | 1.3% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 48.21 | 1 | < 0.1% | |
| 24.39 | 1 | < 0.1% | |
| 15.52 | 1 | < 0.1% | |
| 15.17 | 1 | < 0.1% | |
| 14.72 | 1 | < 0.1% |
room_type
Categorical
| Distinct count | 4 |
|---|---|
| Unique (%) | < 0.1% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Entire home/apt | |
|---|---|
| Private room | |
| Hotel room | 1510 |
| Value | Count | Frequency (%) | |
| Entire home/apt | 47110 | 55.3% | |
| Private room | 36002 | 42.2% | |
| Hotel room | 1510 | 1.8% | |
| Shared room | 634 | 0.7% |
| Max length | 15 |
|---|---|
| Mean length | 13.61485409 |
| Min length | 10 |
| Contains chars | True |
| Contains digits | False |
| Contains spaces | True |
| Contains non-words | True |
security_deposit
Numeric
| Distinct count | 379 |
|---|---|
| Unique (%) | 0.4% |
| Missing (%) | 0.0% |
| Missing (n) | 0 |
| Infinite (%) | 0.0% |
| Infinite (n) | 0 |
| Mean | 128.8998428 |
|---|---|
| Minimum | 0 |
| Maximum | 17827 |
| Zeros (%) | 57.8% |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| Median | 0 |
| Q3 | 200 |
| 95-th percentile | 500 |
| Maximum | 17827 |
| Range | 17827 |
| Interquartile range | 200 |
Descriptive statistics
| Standard deviation | 276.0967007 |
|---|---|
| Coef of variation | 2.141947535 |
| Kurtosis | 251.9389623 |
| Mean | 128.8998428 |
| MAD | 157.6942879 |
| Skewness | 8.659770901 |
| Sum | 10989485 |
| Variance | 76229.38812 |
| Memory size | 666.2 KiB |
| Value | Count | Frequency (%) | |
| 0 | 49259 | 57.8% | |
| 100 | 6014 | 7.1% | |
| 200 | 4994 | 5.9% | |
| 250 | 3644 | 4.3% | |
| 300 | 3322 | 3.9% | |
| 500 | 3283 | 3.9% | |
| 150 | 2904 | 3.4% | |
| 85 | 1958 | 2.3% | |
| 495 | 1324 | 1.6% | |
| 350 | 1017 | 1.2% | |
| Other values (369) | 7537 | 8.8% |
Minimum 5 values
| Value | Count | Frequency (%) | |
| 0 | 49259 | 57.8% | |
| 56 | 1 | < 0.1% | |
| 57 | 1 | < 0.1% | |
| 60 | 16 | < 0.1% | |
| 61 | 6 | < 0.1% |
Maximum 5 values
| Value | Count | Frequency (%) | |
| 17827 | 1 | < 0.1% | |
| 4098 | 1 | < 0.1% | |
| 4069 | 1 | < 0.1% | |
| 4051 | 1 | < 0.1% | |
| 4049 | 1 | < 0.1% |
First rows
| accommodates | availability_365 | bathrooms | bed_type | bedrooms | beds | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | cancellation_policy | cleaning_fee | days_from_last_review | df_index | experiences_offered | extra_people | guests_included | host_days | host_has_profile_pic | host_identity_verified | host_is_superhost | instant_bookable | is_location_exact | maximum_nights | minimum_nights | neighbourhood_cleansed | number_of_reviews | number_of_reviews_ltm | price | property_type | require_guest_phone_verification | require_guest_profile_picture | requires_license | review_scores_accuracy | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | reviews_per_month | room_type | security_deposit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 4.0 | 344.0 | 1.0 | Real Bed | 1.0 | 1.0 | 2.0 | 2.0 | 0.0 | 0.0 | strict_14_with_grace_period | 30.0 | 67.0 | 0 | family | 20.0 | 2.0 | 3634.0 | 0 | 0 | 0 | 0 | 0 | 180.0 | 2.0 | Lambeth | 184.0 | 1.0 | 88.0 | Apartment | 0 | 0 | 0 | 9.0 | 10.0 | 9.0 | 10.0 | 9.0 | 92.0 | 9.0 | 1.59 | Entire home/apt | 400.0 |
| 1 | 2.0 | 353.0 | 1.0 | Real Bed | 1.0 | 1.0 | 3.0 | 1.0 | 2.0 | 0.0 | moderate | 15.0 | 97.0 | 1 | business | 15.0 | 1.0 | 3590.0 | 0 | 0 | 0 | 0 | 0 | 29.0 | 1.0 | Islington | 16.0 | 2.0 | 65.0 | Apartment | 0 | 0 | 0 | 9.0 | 9.0 | 10.0 | 10.0 | 9.0 | 96.0 | 9.0 | 0.14 | Private room | 100.0 |
| 2 | 2.0 | 114.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | strict_14_with_grace_period | 50.0 | 19.0 | 2 | romantic | 0.0 | 2.0 | 3571.0 | 0 | 0 | 0 | 0 | 0 | 50.0 | 30.0 | Kensington and Chelsea | 87.0 | 6.0 | 100.0 | Apartment | 0 | 0 | 0 | 10.0 | 10.0 | 10.0 | 10.0 | 10.0 | 96.0 | 9.0 | 0.73 | Entire home/apt | 150.0 |
| 3 | 6.0 | 265.0 | 2.0 | Real Bed | 3.0 | 4.0 | 15.0 | 15.0 | 0.0 | 0.0 | strict_14_with_grace_period | 65.0 | 88.0 | 3 | none | 10.0 | 4.0 | 3541.0 | 0 | 0 | 0 | 0 | 0 | 365.0 | 3.0 | Westminster | 41.0 | 5.0 | 300.0 | Apartment | 0 | 0 | 0 | 10.0 | 9.0 | 9.0 | 9.0 | 10.0 | 94.0 | 9.0 | 0.40 | Entire home/apt | 350.0 |
| 4 | 2.0 | 346.0 | 1.5 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | moderate | 70.0 | 99.0 | 4 | family | 0.0 | 2.0 | 3639.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 30.0 | Wandsworth | 93.0 | 1.0 | 175.0 | Townhouse | 0 | 0 | 0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 98.0 | 9.0 | 0.86 | Entire home/apt | 250.0 |
| 5 | 4.0 | 147.0 | 1.0 | Real Bed | 2.0 | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | moderate | 50.0 | 52.0 | 5 | none | 11.0 | 2.0 | 3452.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 90.0 | Wandsworth | 31.0 | 5.0 | 65.0 | Apartment | 0 | 0 | 0 | 10.0 | 9.0 | 9.0 | 10.0 | 9.0 | 92.0 | 9.0 | 0.72 | Entire home/apt | 250.0 |
| 6 | 2.0 | 288.0 | 1.5 | Real Bed | 1.0 | 1.0 | 3.0 | 0.0 | 3.0 | 0.0 | strict_14_with_grace_period | 0.0 | 79.0 | 6 | none | 8.0 | 1.0 | 3450.0 | 0 | 0 | 0 | 0 | 0 | 1120.0 | 10.0 | Barnet | 122.0 | 5.0 | 29.0 | House | 0 | 0 | 0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 95.0 | 10.0 | 1.06 | Private room | 100.0 |
| 7 | 4.0 | 339.0 | 1.0 | Real Bed | 1.0 | 3.0 | 3.0 | 3.0 | 0.0 | 0.0 | strict_14_with_grace_period | 75.0 | 55.0 | 7 | none | 15.0 | 3.0 | 3436.0 | 0 | 0 | 0 | 0 | 0 | 365.0 | 3.0 | Islington | 63.0 | 9.0 | 147.0 | Apartment | 0 | 0 | 0 | 8.0 | 9.0 | 9.0 | 9.0 | 9.0 | 85.0 | 8.0 | 0.58 | Entire home/apt | 100.0 |
| 8 | 2.0 | 336.0 | 1.5 | Real Bed | 1.0 | 1.0 | 2.0 | 0.0 | 2.0 | 0.0 | strict_14_with_grace_period | 10.0 | 77.0 | 8 | none | 12.0 | 1.0 | 3396.0 | 0 | 0 | 0 | 0 | 0 | 30.0 | 1.0 | Newham | 115.0 | 10.0 | 34.0 | Townhouse | 0 | 0 | 0 | 10.0 | 10.0 | 10.0 | 10.0 | 9.0 | 97.0 | 10.0 | 1.03 | Private room | 0.0 |
| 9 | 2.0 | 365.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 0.0 | 1.0 | 0.0 | flexible | 0.0 | 112.0 | 9 | none | 0.0 | 1.0 | 3380.0 | 0 | 0 | 0 | 0 | 0 | 21.0 | 1.0 | Hounslow | 5.0 | 2.0 | 100.0 | House | 0 | 0 | 0 | 9.0 | 10.0 | 10.0 | 10.0 | 10.0 | 88.0 | 8.0 | 0.05 | Private room | 0.0 |
Last rows
| accommodates | availability_365 | bathrooms | bed_type | bedrooms | beds | calculated_host_listings_count | calculated_host_listings_count_entire_homes | calculated_host_listings_count_private_rooms | calculated_host_listings_count_shared_rooms | cancellation_policy | cleaning_fee | days_from_last_review | df_index | experiences_offered | extra_people | guests_included | host_days | host_has_profile_pic | host_identity_verified | host_is_superhost | instant_bookable | is_location_exact | maximum_nights | minimum_nights | neighbourhood_cleansed | number_of_reviews | number_of_reviews_ltm | price | property_type | require_guest_phone_verification | require_guest_profile_picture | requires_license | review_scores_accuracy | review_scores_checkin | review_scores_cleanliness | review_scores_communication | review_scores_location | review_scores_rating | review_scores_value | reviews_per_month | room_type | security_deposit | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85246 | 1.0 | 173.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | 0.0 | 0.0 | 85264 | none | 0.0 | 1.0 | 1.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 1.0 | Redbridge | 0.0 | 0.0 | 101.0 | House | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 0.0 |
| 85247 | 4.0 | 307.0 | 1.0 | Real Bed | 2.0 | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | 0.0 | 0.0 | 85265 | none | 0.0 | 1.0 | 1190.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 2.0 | Richmond upon Thames | 0.0 | 0.0 | 105.0 | House | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 0.0 |
| 85248 | 2.0 | 80.0 | 1.0 | Real Bed | 1.0 | 2.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | 0.0 | 0.0 | 85266 | none | 0.0 | 1.0 | 1522.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 1.0 | Lewisham | 0.0 | 0.0 | 78.0 | Apartment | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 0.0 |
| 85249 | 2.0 | 73.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 1.0 | 0.0 | 0.0 | strict_14_with_grace_period | 0.0 | 0.0 | 85267 | none | 0.0 | 1.0 | 133.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 2.0 | Enfield | 0.0 | 0.0 | 30.0 | Apartment | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 100.0 |
| 85250 | 2.0 | 30.0 | 1.0 | Real Bed | 2.0 | 2.0 | 1.0 | 0.0 | 1.0 | 0.0 | flexible | 0.0 | 0.0 | 85268 | none | 0.0 | 1.0 | 2564.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 6.0 | Kensington and Chelsea | 0.0 | 0.0 | 56.0 | Apartment | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Private room | 0.0 |
| 85251 | 5.0 | 45.0 | 1.5 | Real Bed | 1.0 | 3.0 | 7.0 | 7.0 | 0.0 | 0.0 | flexible | 40.0 | 0.0 | 85269 | none | 0.0 | 1.0 | 415.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 2.0 | Ealing | 0.0 | 0.0 | 85.0 | Apartment | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 0.0 |
| 85252 | 2.0 | 2.0 | 2.0 | Real Bed | 1.0 | 1.0 | 2.0 | 0.0 | 2.0 | 0.0 | flexible | 0.0 | 0.0 | 85270 | none | 0.0 | 1.0 | 733.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 1.0 | Camden | 0.0 | 0.0 | 35.0 | Apartment | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Private room | 0.0 |
| 85253 | 6.0 | 173.0 | 4.0 | Real Bed | 3.0 | 3.0 | 1.0 | 1.0 | 0.0 | 0.0 | flexible | 0.0 | 0.0 | 85271 | none | 0.0 | 1.0 | 1.0 | 0 | 0 | 0 | 0 | 0 | 1125.0 | 7.0 | Westminster | 0.0 | 0.0 | 420.0 | Condominium | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 0.0 |
| 85254 | 2.0 | 233.0 | 1.0 | Real Bed | 1.0 | 1.0 | 1.0 | 0.0 | 1.0 | 0.0 | flexible | 0.0 | 0.0 | 85272 | none | 0.0 | 1.0 | 1.0 | 0 | 0 | 0 | 0 | 0 | 15.0 | 1.0 | Hillingdon | 0.0 | 0.0 | 35.0 | House | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Private room | 81.0 |
| 85255 | 5.0 | 32.0 | 1.0 | Real Bed | 2.0 | 2.0 | 3.0 | 2.0 | 1.0 | 0.0 | flexible | 0.0 | 0.0 | 85273 | none | 0.0 | 1.0 | 2326.0 | 0 | 0 | 0 | 0 | 0 | 7.0 | 2.0 | Lambeth | 0.0 | 0.0 | 50.0 | Apartment | 0 | 0 | 0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | Entire home/apt | 0.0 |